IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'CGO_TriviaResult')
                    AND OBJECTPROPERTY(id, N'IsTable') = 1 ) 
  BEGIN
    DROP TABLE dbo.CGO_TriviaResult
  END


CREATE TABLE [dbo].[CGO_TriviaResult]
  (
    [GameEnrollmentID] [int] NOT NULL,    
    [QuestionIndex] [int] NOT NULL,    
    [QuestionID] [int] NOT NULL,
    [ResultStatusID] [int] NULL,
    [UserAnswerID] [int] NULL,
    [Correct] [bit] NULL,
    [LastUpdateDate] [datetime] NULL
  )
ON
  [PRIMARY]
GO